USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[WeaponsInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.WeaponsInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Weapons Table Insert
-- =============================================
CREATE PROCEDURE WeaponsInsert

            @WeaponId int,
            @WeaponShortName varchar(50),
            @WeaponFullName varchar(50),
            @ClassId int

AS
BEGIN

INSERT INTO [Weapons]
           ([WeaponId]
           ,[WeaponShortName]
           ,[WeaponFullName]
           ,[ClassId])
     VALUES
           (@WeaponId,
            @WeaponShortName,
            @WeaponFullName,
            @ClassId)
END
GO
